The SAS® Revenue Optimization %TKMI_JOB_RO etl_end_service task might generate the following error in the MerchIntelGridSvr.log:
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : Processing Benefits Tracking
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : ERROR: Assertion failed: prod_geos_size>0, file /sas/dev/mva-f3ro52/dippr/src/rpp_cost_service.c, line 1699
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : ERROR: [rpp_cost_service_run] prod_geos_size is zero
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT:
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_pdr : Completed Processing Geo_Prod_Promo_Price_Avg in <n> seconds
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_pga : Completed Processing Geo_Prod_Agg in <n> seconds
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt : Error: job 'prep_<partition_id>_bt' encountered a fatal error
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: <HH:MM:SS> prep_<partition_id>_bt :
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: ERROR: TKTException code = 6 (Access violation)
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #4 0x00007fd60e97e7ec in tkmi_exception_handler (thread=0x4b75, ctxt=0x7fd5a2af4e9c, code=TKTE_UnknownException) at /sas/dev/mva-f3ro52/di/src/tkmi_exception.c:88
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #5 0x00007fd61849e196 in bktExcept () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #6 0x00007fd6184a119b in bkt_segv () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #7 0x00007fd61849e764 in bkt_signal_handler () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #8
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #9 assert_fn (cond=-264706176, cond_str=0x0, file=0x0, line=65792, msg=0x7fd5a2af6700 "") at /sas/dev/mva-f3ro52/di/src/base.c:1648
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #10 0x00007fd60ec37e0f in rpp_cost_service_run (rpp_manager=0x35f038e780, prod_geos=0x0, prod_geos_size=0, start_dt=65792, end_dt=-1565563136, plan_status_cd=-1816096496, plan_sk_list=0x7fd60ee674d8 "", use_freeze_period=1, output_promotion_fee=0, opt=0x7fd5a2ae89c0) at /sas/dev/mva-f3ro52/dippr/src/rpp_cost_service.c:1699
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #11 0x00007fd60ebe0e40 in load_cost (ctx=0x35f038e780) at /sas/dev/mva-f3ro52/dipca/src/rpo_benefits_tracking_service.c:459
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #12 0x00007fd60ebdf4f7 in rpo_benefits_tracking_service_batch (dim=0x7fd6094e21b0) at /sas/dev/mva-f3ro52/dipca/src/rpo_benefits_tracking_service.c:1322
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #13 0x00007fd60eab87ab in prep_service_bt (context=0x35f038e780) at /sas/dev/mva-f3ro52/di/src/prep_service.c:552
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #14 0x00007fd60e96a668 in logic_fn (ctxt=0x7fd61837c0a0, req=0x7fd5dd6bb5f0, thread=0x7fd6183a8e10, cb=0x7fd6096b0928) at /sas/dev/mva-f3ro52/di/src/job_manager.c:1281
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #15 0x00007fd60d5a6d0b in basicPuddleMain () from <sasroot>/SASFoundation/9.3/sasexe/tkepdl.so
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #16 0x00007fd61849c9a6 in sktMain () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #17 0x00007fd61849dffb in bktMain () from <sasroot>/SASFoundation/9.3/sasexe/tkmk.so
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #18 0x00000035f08079d1 in start_thread () from /lib64/libpthread.so.0
<YYYY-MM-DD HH:MM:SS,sss> [pool-<n>-thread-<n> DEBUG - STDOUT: #19 0x00000035f00e8b6d in clone () from /lib64/libc.so.6
The error is generated during SAS® Regular Price Optimization benefits tracking processing that occurs during the batch preparation jobs in the etl_end_service task.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 5.2_M3 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.